User interface for generating data visualizations that use table calculations

ABSTRACT

An electronic device displays a chart, which includes visual marks that represent calculated values derived from a set of data, and panes formed by intersection of rows and columns. A current focus is on a first visual mark at a first position. The device concurrently displays a chart-calculations-options area, which includes display options for a type of calculation and a type of data partitioning. Visual marks in a first set of visual marks are visually distinguished from other visual marks. The first set of visual marks includes the first visual mark, and corresponds to a first selected option for a type of calculation and a first selected option for a type of data partitioning. The device detects an input that selects a second option for a type of data partitioning, and, in response, visually distinguishes visual marks in a second set of visual marks in accordance with the selection.

RELATED APPLICATIONS

This application is a continuation of U.S. patent application Ser. No.14/846,979, filed Sep. 7, 2015, entitled “Devices and Methods forSelecting and Displaying Chart Calculation Options,” which claimspriority to U.S. Provisional Application Ser. No. 62/047,641, filed Sep.8, 2014, entitled “Devices and Methods for Selecting and DisplayingChart Calculation Options,” each of which is incorporated by referenceherein in its entirety.

TECHNICAL FIELD

This invention relates generally to devices and methods for displayingcharts, including but not limited to selecting and displaying chartcalculation options.

BACKGROUND

Data sets with hundreds of variables arise today in many contexts,including, for example: gene expression data for uncovering the linkbetween the genome and the various proteins for which it codes;demographic and consumer profiling data for capturing underlyingsociological and economic trends; sales and marketing data for hugenumbers of products in vast and ever-changing marketplaces; andenvironmental measurements for understanding phenomena such aspollution, meteorological changes and resource impact issues.

Data visualization is a powerful tool for exploring large data sets,both by itself and coupled with data mining algorithms. Graphical viewsprovide user-friendly ways to visualize and interpret data.

However, the task of effectively visualizing large databases imposessignificant demands on the human-computer interface to the visualizationsystem. Even specifying what should be calculated and shown in a chartor other data visualization can be problematic.

Consequently, there is a need for faster, more efficient methods andinterfaces for selecting and displaying chart calculation options. Suchmethods and interfaces may complement or replace conventional methodsfor selecting and displaying chart calculation options. Such methods andinterfaces reduce the cognitive burden on a user and produce a moreefficient human-machine interface. For battery-operated devices, suchmethods and interfaces conserve power and increase the time betweenbattery charges.

SUMMARY

The above deficiencies and other problems associated with selecting anddisplaying chart calculation options are reduced or eliminated by thedisclosed methods, devices, and storage mediums. Various implementationsof methods, devices, and storage mediums within the scope of theappended claims each have several aspects, no single one of which issolely responsible for the attributes described herein. Without limitingthe scope of the appended claims, after considering this disclosure, onewill understand how the aspects of various implementations are used tovisualize data.

In accordance with some embodiments, a method is performed at anelectronic device with a display. The method includes displaying a charton the display. The chart includes visual marks that representcalculated values derived from a set of data. The chart includes aplurality of rows and a plurality of columns. The chart includes aplurality of panes formed by intersection of the plurality of rows andthe plurality of columns. A current focus is on a first visual mark at afirst position in a first pane in the plurality of panes. The methodalso includes concurrently displaying a chart-calculations-options areawith the chart on the display. The chart-calculations-options areaincludes display of one or more options for a type of calculation, andone or more options for a type of data partitioning. Visual marks in afirst set of visual marks are visually distinguished from other visualmarks in the chart. The first set of visual marks includes the firstvisual mark, and the first set of visual marks corresponds to a firstselected option for a type of calculation and a first selected optionfor a type of data partitioning. In some embodiments, the method alsoincludes detecting an input that selects a second option for a type ofdata partitioning, distinct from the first option for a type of datapartitioning; and, in response to detecting the input that selects thesecond option for a type of data partitioning, visually distinguishingvisual marks in a second set of visual marks from other visual marks inthe chart. The second set of visual marks is distinct from the first setof visual marks. The second set of visual marks includes a visual markat the first position in the first pane. The second set of visual markscorresponds to the first selected option for a type of calculation andthe second selected option for a type of data partitioning.

In accordance with some embodiments, an electronic device includes adisplay, one or more processors, memory, and one or more programs; theone or more programs are stored in the memory and configured to beexecuted by the one or more processors and the one or more programsinclude instructions for performing the operations of the methoddescribed above. In accordance with some embodiments, a graphical userinterface on an electronic device with a display, a memory, and one ormore processors to execute one or more programs stored in the memoryincludes one or more of the elements displayed in the method describedabove, which are updated in response to inputs, as described in themethod described above. In accordance with some embodiments, a computerreadable storage medium has stored therein instructions which whenexecuted by an electronic device with a display and one or moreprocessors, cause the device to perform the operations of the methoddescribed above. In accordance with some embodiments, an electronicdevice includes: a display, and means for performing the operations ofthe method described above.

Thus, electronic devices with displays are provided with faster, moreefficient methods and interfaces for selecting and displaying chartcalculation options, thereby increasing the effectiveness, efficiency,and user satisfaction with such devices. Such methods and interfaces maycomplement or replace conventional methods for selecting and di splayingchart calculation options.

BRIEF DESCRIPTION OF THE DRAWINGS

So that the present disclosure can be understood in greater detail, amore particular description may be had by reference to the features ofvarious embodiments, some of which are illustrated in the appendeddrawings. The appended drawings, however, merely illustrate the morepertinent features of the present disclosure and are therefore not to beconsidered limiting, for the description may admit to other effectivefeatures.

FIG. 1 illustrates a portable electronic device in accordance with someembodiments.

FIG. 2 illustrates an electronic device in accordance with someembodiments.

FIG. 3A is a block diagram illustrating a portable electronic device inaccordance with some embodiments.

FIG. 3B is a block diagram illustrating an electronic device inaccordance with some embodiments.

FIGS. 4A-4P illustrate exemplary user interfaces for selecting anddisplaying chart calculation options in accordance with someembodiments.

FIGS. 5A-5C are flow diagrams illustrating a method of selecting anddisplaying chart calculation options in accordance with someembodiments.

In accordance with common practice the various features illustrated inthe drawings may not be drawn to scale. Accordingly, the dimensions ofthe various features may be arbitrarily expanded or reduced for clarity.In addition, some of the drawings may not depict all of the componentsof a given system or device. Finally, like reference numerals may beused to denote like features throughout the specification and figures.

DETAILED DESCRIPTION

As noted above, the task of effectively visualizing large databasesimposes significant demands on the human-computer interface to thevisualization system. Even specifying what should be calculated andshown in a chart or other data visualization can be problematic.

For example, for a graph containing multiple panes in a grid, a user maywant to make calculations that use data underlying a single pane, a rowof panes, a column of panes, a sub-row of panes, a sub-column of panes,or all of the panes. It may be difficult for a user to specify thedesired calculations and type of data partitioning.

Here, devices and methods are disclosed that improve the selection anddisplay of chart calculations options. The user specifies a type ofcalculation and a type of data partitioning via a chart-calculationsoptions area. The chart is updated in real time in response to the usersselections. In addition, a set of visual marks in the chart (e.g., a setbars in a bar chart) is displayed that are visually distinguished fromother visual marks in the chart (e.g., other bars in the bar chart).This set of visual marks provides a simple, intuitive visual indicationto the user of what chart calculation options have been selected. Thus,the user can immediately tell if the specified type of calculation andthe type of data partitioning are what the user wants. If the specifiedtype of calculation and the type of data partitioning are not what theuser wants, the user can easily change the chart calculation options,see the updated chart, and see a new set of visually distinguished marksthat indicate the currently selected chart calculation options. Thus, auser is able to make the chart intended by the user in a faster,simpler, and more efficient manner.

Below, FIGS. 1-3B provide a description of exemplary devices. FIGS.4A-4P illustrate exemplary user interfaces for selecting and displayingchart calculation options. FIGS. 5A-5C are flow diagrams illustrating amethod of selecting and displaying chart calculation options. The userinterfaces in FIGS. 4A-4P are used to illustrate the processes in FIGS.5A-5C.

Reference will now be made in detail to embodiments, examples of whichare illustrated in the accompanying drawings. In the following detaileddescription, numerous specific details are set forth in order to providea thorough understanding of the various described embodiments. However,it will be apparent to one of ordinary skill in the art that the variousdescribed embodiments may be practiced without these specific details.In other instances, well-known methods, procedures, components,circuits, and networks have not been described in detail so as not tounnecessarily obscure aspects of the embodiments.

It will also be understood that, although the terms first, second, etc.are, in some instances, used herein to describe various elements, theseelements should not be limited by these terms. These terms are only usedto distinguish one element from another. For example, a first set ofvisual marks could be termed a second set of visual marks, and,similarly, a second set of visual marks could be termed a first set ofvisual marks, without departing from the scope of the various describedembodiments. The first set of visual marks and the second set of visualmarks are both sets of visual marks, but they are not the same set ofvisual marks.

The terminology used in the description of the various describedembodiments herein is for the purpose of describing particularembodiments only and is not intended to be limiting. As used in thedescription of the various described embodiments and the appendedclaims, the singular forms “a”, “an” and “the” are intended to includethe plural forms as well, unless the context clearly indicatesotherwise. It will also be understood that the term “and/or” as usedherein refers to and encompasses any and all possible combinations ofone or more of the associated listed items. It will be furtherunderstood that the terms “includes,” “including,” “comprises,” and/or“comprising,” when used in this specification, specify the presence ofstated features, integers, steps, operations, elements, and/orcomponents, but do not preclude the presence or addition of one or moreother features, integers, steps, operations, elements, components,and/or groups thereof.

As used herein, the term “if” is, optionally, construed to mean “when”or “upon” or “in response to determining” or “in response to detecting”or “in accordance with a determination that,” depending on the context.Similarly, the phrase “if it is determined” or “if [a stated conditionor event] is detected” is, optionally, construed to mean “upondetermining” or “in response to determining” or “upon detecting [thestated condition or event]” or “in response to detecting [the statedcondition or event]” or “in accordance with a determination that [astated condition or event] is detected,” depending on the context.

Attention is now directed toward embodiments of electronic devices withdisplays. Embodiments of electronic devices and user interfaces for suchdevices are described. In some embodiments, the device is a portablecommunications device, such as a mobile telephone, that also containsother functions, such as PDA and/or music player functions. Otherportable electronic devices, such as laptops or tablet computers are,optionally, used. It should also be understood that, in someembodiments, the device is not a portable communications device, but isa desktop computer with a display. In the discussion that follows, anelectronic device that includes a display is described. The electronicdevice includes one or more physical user-interface devices, such as atouch-sensitive display, a track pad, a physical keyboard, a mouse,and/or a joystick.

FIG. 1 illustrates a portable electronic device 100 in accordance withsome embodiments. In some embodiments, device 100 is a mobile phone, alaptop computer, a personal digital assistant (PDA), or a tabletcomputer. In some embodiments, portable electronic device 100 includestouch screen 102, which is also sometimes called a touch-sensitivedisplay and/or a touch-sensitive display system. Touch screen 102optionally displays one or more graphics within a user interface (UI).In some embodiments, a user is enabled to select one or more of thegraphics by making a touch input (e.g., touch input 108) on thegraphics. In some instances, the touch input is a contact on the touchscreen. In some instances, the touch input is a gesture that includes acontact and movement of the contact on the touch screen. In someinstances, the gesture optionally includes one or more taps, one or moreswipes (from left to right, right to left, upward and/or downward)and/or a rolling of a finger (from right to left, left to right, upwardand/or downward) that has made contact with device 100. For example, atouch input on the graphics is optionally made with one or more fingers110 (not drawn to scale in the figure) or one or more styluses 112 (notdrawn to scale in the figure). In some embodiments, selection of one ormore graphics occurs when the user breaks contact with the one or moregraphics. In some circumstances, inadvertent contact with a graphic doesnot select the graphic. For example, a swipe gesture that sweeps over avisual mark optionally does not select the visual mark when the gesturecorresponding to selection is a tap. Device 100 optionally also includesone or more physical buttons and/or other input/output devices, such asa microphone for verbal inputs, a physical keyboard, a mouse, and/or ajoystick.

FIG. 2 illustrates an electronic device 200 in accordance with someembodiments. Device 200 need not be portable. In some embodiments,device 200 is a laptop computer, a desktop computer, a tablet computer,or an educational device. Device 200 includes screen 202. In someembodiments, device 200 includes touch-sensitive surface 204. Screen 202optionally displays one or more graphics within a UI. In someembodiments, a user is enabled to select one or more of the graphics bymaking a touch input (e.g., touch input 210) on touch-sensitive surface204 such that a corresponding cursor (e.g., cursor 212) on screen 202selects the one or more graphics. For example, when an input is detectedon touch-sensitive surface 204 while cursor 212 is over a particularuser interface element (e.g., a button, window, slider or other userinterface element), the particular user interface element is adjusted inaccordance with the detected input.

FIG. 3A is a block diagram illustrating a portable electronic device100, in accordance with some embodiments. It should be appreciated thatdevice 100 is only one example of a portable electronic device, and thatdevice 100 optionally has more or fewer components than shown,optionally combines two or more components, or optionally has adifferent configuration or arrangement of the components. The variouscomponents shown in FIG. 3A are implemented in hardware, software, or acombination of both hardware and software, including one or more signalprocessing and/or application specific integrated circuits.

Device 100 includes one or more processing units (CPU's) 302,input/output (I/O) subsystem 306, memory 308 (which optionally includesone or more computer readable storage mediums), and networkcommunications interface 310. These components optionally communicateover one or more communication buses or signal lines 304. Communicationbuses 304 optionally include circuitry (sometimes called a chipset) thatinterconnects and controls communications between system components.

Memory 308 includes high-speed random access memory, such as DRAM, SRAM,DDR RAM or other random access solid state memory devices, and mayinclude non-volatile memory, such as one or more magnetic disk storagedevices, optical disk storage devices, flash memory devices, or othernon-volatile solid state storage devices. Memory 308 optionally includesone or more storage devices remotely located from processor(s) 302.Memory 308, or alternately the non-volatile memory device(s) withinmemory 308, comprises a non-transitory computer readable storage medium.

In some embodiments, the software components stored in memory 308include operating system 318, communication module 320, input/output(I/O) module 322, and applications 328. In some embodiments, one or moreof the various modules comprises a set of instructions in memory 308. Insome embodiments, memory 308 stores one or more data sets in one or moredatabase(s) 332.

Operating system 318 (e.g., Darwin, RTXC, LINUX, UNIX, OS X, WINDOWS, oran embedded operating system such as VxWorks) includes various softwarecomponents and/or drivers for controlling and managing general systemtasks (e.g., memory management, storage device control, powermanagement, etc.) and facilitates communication between various hardwareand software components.

Communication module 320 connects the electronic device 100 to othercomputers via the one or more communication network interfaces 310(wired or wireless) and one or more communication networks, such as theInternet, cellular telephone networks, mobile data networks, other widearea networks, local area networks, metropolitan area networks, and soon; facilitates communication with other devices over one or moreexternal ports; and also includes various software components forhandling data received by from other devices.

I/O module 322 includes touch input sub-module 324 and graphicssub-module 326. Touch input sub-module 324 optionally detects touchinputs with touch screen 102 and other touch sensitive devices (e.g., atouchpad or physical click wheel). Touch input sub-module 324 includesvarious software components for performing various operations related todetection of a touch input, such as determining if contact has occurred(e.g., detecting a finger-down event), determining if there is movementof the contact and tracking the movement across the touch-sensitivesurface (e.g., detecting one or more finger-dragging events), anddetermining if the contact has ceased (e.g., detecting a finger-up eventor a break in contact). Touch input sub-module 324 receives contact datafrom the touch-sensitive surface (e.g., touch screen 102). Theseoperations are, optionally, applied to single touch inputs (e.g., onefinger contacts) or to multiple simultaneous touch inputs (e.g.,“multitouch”/multiple finger contacts). In some embodiments, touch inputsub-module 324 detects contact on a touchpad.

Touch input sub-module 324 optionally detects a gesture input by a user.Different gestures on the touch-sensitive surface have different contactpatterns. Thus, a gesture is, optionally, detected by detecting aparticular contact pattern. For example, detecting a finger tap gestureincludes detecting a finger-down event followed by detecting a finger-up(lift off) event at the same position (or substantially the sameposition) as the finger-down event (e.g., at the position of an datamark). As another example, detecting a finger swipe gesture on thetouch-sensitive surface includes detecting a finger-down event followedby detecting one or more finger-dragging events, and subsequentlyfollowed by detecting a finger-up (lift off) event.

Graphics sub-module 326 includes various known software components forrendering and displaying graphics on touch screen 102 or other display,including components for changing the visual impact (e.g., brightness,transparency, saturation, contrast or other visual property) of graphicsthat are displayed. As used herein, the term “graphics” includes anyobject that can be displayed to a user, including without limitationdata visualizations, icons (such as user-interface objects includingsoft keys), text, digital images, animations and the like. In someembodiments, graphics sub-module 326 stores data representing graphicsto be used. Each graphic is, optionally, assigned a corresponding code.Graphics sub-module 326 receives, from applications etc., one or morecodes specifying graphics to be displayed along with, if necessary,coordinate data and other graphic property data, and then generatesscreen image data to output to the display or touch screen.

Applications 328 optionally include data visualization module 330 fordisplaying graphical views of data (e.g., in a chart) and one or moreother applications. Examples of other applications that are, optionally,stored in memory 308 include other word processing applications, emailapplications, and presentation applications.

In conjunction with I/O interface 306, including touch screen 102,CPU(s) 302, and/or database(s) 332, data visualization module 330includes executable instructions for displaying and manipulating variousgraphical views of data.

Each of the above identified modules and applications correspond to aset of executable instructions for performing one or more functionsdescribed above and the methods described in this application (e.g., thecomputer-implemented methods and other information processing methodsdescribed herein). These modules (i.e., sets of instructions) need notbe implemented as separate software programs, procedures or modules, andthus various subsets of these modules are, optionally, combined orotherwise re-arranged in various embodiments. In some embodiments,memory 308 optionally stores a subset of the modules and data structuresidentified above. Furthermore, memory 308 optionally stores additionalmodules and data structures not described above.

FIG. 3B is a block diagram illustrating electronic device 200 inaccordance with some embodiments. It should be appreciated that device200 is only one example of a electronic device, and that device 200optionally has more or fewer components than shown, optionally combinestwo or more components, or optionally has a different configuration orarrangement of the components. The various components shown in FIG. 3Bare implemented in hardware, software, or a combination of both hardwareand software, including one or more signal processing and/or applicationspecific integrated circuits.

Device 200 typically includes one or more processing units (CPU's) 352,one or more network or other communications interfaces 362, memory 350,I/O interface 356, and one or more communication buses 354 forinterconnecting these components. Communication buses 354 optionallyinclude circuitry (sometimes called a chipset) that interconnects andcontrols communications between system components.

I/O interface 306 comprises screen 202 (also sometimes called adisplay), touch-sensitive surface 204, and one or more sensor(s) 360(e.g., optical, acceleration, proximity, and/or touch-sensitivesensors). I/O interface 356 optionally includes a keyboard and/or mouse(or other pointing device) 358. I/O interface 356 couples input/outputperipherals on device 200, such as screen 202, touch-sensitive surface204, other input devices 358, and one or more sensor(s) 360, to CPU(s)352 and/or memory 350.

Screen 202 provides an output interface between the device and a user.Screen 202 displays visual output to the user. The visual outputoptionally includes graphics, text, icons, data marks, and anycombination thereof (collectively termed “graphics”). In someembodiments, some or all of the visual output corresponds touser-interface objects. Screen 202 optionally uses LCD (liquid crystaldisplay) technology, LPD (light emitting polymer display) technology, orLED (light emitting diode) technology, although other displaytechnologies are used in other embodiments.

In some embodiments, device 200 includes touch-sensitive surface 204(e.g., a touchpad) for detecting touch inputs. Touch-sensitive surface204 accepts input from the user via touch inputs. For example, touchinput 210 in FIG. 2. Touch-sensitive surface 204 (along with anyassociated modules and/or sets of instructions in memory 350) detectstouch inputs and converts the detected inputs into interaction withuser-interface objects (e.g., one or more icons, data marks, or images)that are displayed on screen 202. In an exemplary embodiment, a point ofcontact between touch-sensitive surface 204 and the user corresponds toa finger of the user.

Memory 350 includes high-speed random access memory, such as DRAM, SRAM,DDR RAM or other random access solid state memory devices; andoptionally includes non-volatile memory, such as one or more magneticdisk storage devices, optical disk storage devices, flash memorydevices, or other non-volatile solid state storage devices. Memory 350optionally includes one or more storage devices remotely located fromCPU(s) 352. In some embodiments, the software components stored inmemory 350 include operating system 364, communication module 366,input/output (I/O) module 368, and applications 374. In someembodiments, one or more of the various modules comprises a set ofinstructions in memory 350. In some embodiments, memory 350 stores oneor more data sets in one or more database(s) 378. In some embodiments,I/O module 368 includes touch input sub-module 370 and graphicssub-module 372. In some embodiments, applications 374 include datavisualization module 376.

In some embodiments, memory 350 stores programs, modules, and datastructures analogous to the programs, modules, and data structuresstored in memory 308 of portable multifunction device 100 (FIG. 3A), ora subset thereof. Furthermore, memory 350 optionally stores additionalprograms, modules, and data structures not present in memory 308 ofportable multifunction device 100. For example, memory 350 of device 200optionally stores drawing, presentation, and word processingapplications, while memory 308 of portable multifunction device 100(FIG. 3A) optionally does not store these modules.

Device 200 also includes a power system for powering the variouscomponents. The power system optionally includes a power managementsystem, one or more power sources (e.g., battery, alternating current(AC)), a recharging system, a power failure detection circuit, a powerconverter or inverter, a power status indicator (e.g., a light-emittingdiode (LED)) and any other components associated with the generation,management and distribution of power in portable devices.

Each of the above identified elements in FIG. 3B is, optionally, storedin one or more of the previously mentioned memory devices. Each of theabove identified modules corresponds to a set of instructions forperforming a function described above. The above identified modules orprograms (i.e., sets of instructions) need not be implemented asseparate software programs, procedures or modules, and thus varioussubsets of these modules are, optionally, combined or otherwisere-arranged in various embodiments. In some embodiments, memory 350optionally stores a subset of the modules and data structures identifiedabove. Furthermore, memory 350 optionally stores additional modules anddata structures not described above.

Attention is now directed towards embodiments of user interfaces (“UI”)and associated processes that are, optionally, implemented on device 100or device 200. The following examples are shown using a mouse and cursorwith a display. However, it should be understood that, in someembodiments, the inputs are detected on a touch-sensitive surface, suchas a touch screen or trackpad, instead of using mouse-based inputs.

FIGS. 4A-4P illustrate exemplary user interfaces for selecting anddisplaying chart calculation options in accordance with someembodiments. The user interfaces in these figures are used to illustratethe processes described below, including the processes in FIGS. 5A-5C.

FIG. 4A shows a UI 402 that is displaying an exemplary chart 401 ondisplay 202. The chart includes rows 414 (e.g., representing America,APAC, and EMEA regions), columns 446 (e.g., representing quarters), andcolumns 434 (e.g., representing months, which are sub-columns of columns446). The chart includes visual marks 404 (e.g., bars) that representcalculated values derived from a set of data. In FIG. 4A, the visualmarks 462 represent total sales for each month in each region.

FIG. 4B shows a menu 406 added to UI 402 (e.g., by right-clicking on theSUM (Total Sales) icon). In menu 406, the Add Table Calculation icon 408is being selected and activated (e.g. with a pointer and a mouse click).

FIG. 4C shows a UI 410 that is displayed in response to activation ofthe Add Table Calculation icon 408. In UI 410, achart-calculations-options area 420 (e.g., a window) is displayed thatincludes an option 422-1 for a type of calculation (e.g., percent oftotal). In UI 410, a single option for a type of calculation isdisplayed. In other embodiments, multiple options 422 for the type ofcalculation are concurrently displayed. Chart-calculations-options area420 also displays one or more options for a type of data partitioning(for a selected type of calculation), such as the options 424 listed inthe area labeled “Summarize values from.” Chart-calculations-optionsarea 420 optionally includes areas 426 and 428 that provide additionalinformation on how the data in the chart is being partitioned and/orwhich totals are being computed. In some embodiments, the icons in areas426 and 428 can be moved between areas 426 and 428 by a user (e.g., bydragging and dropping) to create a custom type of data partitioning fora selected type of calculation.

In FIG. 4C, in response to activation of the Add Table Calculation icon408, the visual marks 404 (which correspond to total sales per month byregion) are replaced by visual marks 412 at corresponding positions inthe chart. Visual marks 412 represent, for given month in a givenregion, that month's percent of total sales for the region for the year.

In FIG. 4C, the interpretation of visual marks 412 is made clearer to auser by visually distinguishing some of visual marks 412 from the othervisual marks in the chart. Visual marks in a first set of visual marks(namely 412-1 to 412-12) are visually distinguished from other visualmarks in the chart (namely 412-13 to 412-36), by highlighting orotherwise visually emphasizing visual marks in the first set of marksand/or by dimming or otherwise visually deemphasizing the remainingvisual marks in the chart that are not part of the first set of visualmarks. For example, in FIG. 4C, visual marks 412-13 to 412-36 aredimmed, while visual marks 412-1 to 412-12 are not dimmed.

The first set of visual marks (412-1 to 412-12) includes a first visualmark (namely 412-1) at a first position in a first pane 418-1 that has acurrent focus 416-1 (shown by the bold black border around mark 412-1).In some embodiments, when the chart-calculations-options area isinitially displayed, the current focus 416 is put on a visual mark at adefault position in the chart, such as the top, leftmost position in thechart.

The first set of visual marks (412-1 to 412-12) corresponds to a firstselected option for a type of calculation and a first selected optionfor a type of data partitioning (for a selected type of calculation). InFIG. 4C, the first selected option for a type of calculation is option422-1, a “percent of total” calculation. In FIG. 4C, the first selectedoption 424 for a type of data partitioning (for a selected type ofcalculation) is “Table (across),” which corresponds to one row in thechart. By visually distinguishing the first set of visual marks (412-1to 412-12) from other visual marks in the chart (412-13 to 412-36), theuser is given a visual indication of what data is being used tocalculate the values that correspond to visual marks 412. For example,visually distinguishing a single row of visual marks (412-1 to 412-12)informs a user that the “percent of total” calculation is for a total of12 months in a single region. The percentages of the first set of visualmarks (412-1 to 412-12) sum to 100%.

FIG. 4D shows a UI 430 that is displayed in response to detecting aninput (e.g., a click on visual mark 412-13) that changes the currentfocus 416-2 to a second visual mark (e.g., visual mark 412-13) in asecond pane (e.g., 418-5) in the chart. Visual marks in a third set ofvisual marks (namely 412-13 to 412-24) are visually distinguished fromother visual marks in the chart (namely 412-1 to 412-12 and 412-25 to412-36), by highlighting or otherwise visually emphasizing visual marksin the third set of marks and/or by dimming or otherwise visuallydeemphasizing the remaining visual marks in the chart that are not partof the third set of visual marks. For example, in FIG. 4D, visual marks412-1 to 412-12 and 412-25 to 412-36 are dimmed, while visual marks412-13 to 412-24 are not dimmed.

The third set of visual marks (412-13 to 412-24) is distinct from thefirst set of visual marks (412-1 to 412-12). The third set of visualmarks includes the second visual mark (412-13) that has the currentfocus 416-2.

The third set of visual marks corresponds to the first selected optionfor a type of calculation (e.g., option 422-1, a “percent of total”calculation) and the first selected option for a type of datapartitioning (for a selected type of calculation) (e.g., “Table(Across),” which corresponds to one row in the chart). These options arethe same as for the first set of visual marks because the chartcalculation options are the same. As for the first set of visual marks,by visually distinguishing the third set of visual marks (412-13 to412-24) from other visual marks in the chart (412-1 to 412-12 and 412-25to 412-36), the user is given a visual indication of what data is beingused to calculate the values that correspond to visual marks 412. Forexample, visually distinguishing a single row of visual marks (412-13 to412-24) informs a user that the “percent of total” calculation is for atotal of 12 months in a single region. The percentages of the third setof visual marks (412-13 to 412-25) sum to 100%.

FIG. 4E shows a UI 432 that is displayed in response to detecting aninput that selects a second option for a type of data partitioning (fora selected type of calculation) (e.g., a mouse click or finger tapgesture in the chart-calculations-options area 420 on an icon for asecond option for a type of data partitioning, such as “Table(Down),”which corresponds to one column 434-1 in the chart).

Because a different option for a type of data partitioning has beenselected, the chart is recalculated and visual marks 412 (FIG. 5D) arereplaced by visual marks 436. Visual marks in a second set of visualmarks (namely 436-1, 436-13, and 436-25) are visually distinguished fromother visual marks in the chart (namely 436-2 to 436-12, 436-14 to436-24, and 436-26 to 436-36), by highlighting or otherwise visuallyemphasizing visual marks in the second set of marks and/or by dimming orotherwise visually deemphasizing the remaining visual marks in the chartthat are not part of the second set of visual marks. For example, inFIG. 4E, visual marks 436-2 to 436-12, 436-14 to 436-24, and 436-26 to436-36 are dimmed, while visual marks 436-1, 436-13, and 436-25 are notdimmed.

The second set of visual marks (436-1, 436-13, and 436-25) is distinctfrom the first set of visual marks (412-1 to 412-12).

The second set of visual marks includes a visual mark (436-1) at thefirst position in the first pane 418-1, which was previously thelocation of visual mark 412-1 in the first set of visual marks. Visualmark 436-1 has a current focus 416-3 (shown by the bold black borderaround mark 436-1). In some embodiments, when the chart calculationoptions change, the set of visual marks that are visually distinguishedfrom the other visual marks in the chart includes a visual mark at theposition in the chart that had current focus 416 immediately prior tochanging the chart calculation options. In some embodiments, when thechart calculation options change, the current focus 416 is put on avisual mark at a default position in the chart, such as the top,leftmost position in the chart.

The second set of visual marks (436-1, 436-13, and 436-25) correspondsto the first selected option for a type of calculation and the secondselected option for a type of data partitioning (for a selected type ofcalculation). In FIG. 4E, the first selected option for a type ofcalculation is option 422-1, a “percent of total” calculation. In FIG.4E, the second selected option 424 for a type of data partitioning (fora selected type of calculation) is “Table (Down),” which corresponds toone column 434 in the chart. By visually distinguishing the second setof visual marks (436-1, 436-13, and 436-25) from other visual marks inthe chart (436-2 to 436-12, 436-14 to 436-24, and 436-26 to 436-36), theuser is given a visual indication of what data is being used tocalculate the values that correspond to visual marks 412. For example,visually distinguishing a single column of visual marks (436-1, 436-13,and 436-25) informs a user that the “percent of total” calculation isfor a total of 1 month across three regions. The percentages of thesecond set of visual marks (436-1, 436-13, and 436-25) sum to 100%.

FIG. 4F shows a UI 438 that is displayed in response to detecting aninput that selects another option for a type of data partitioning (for aselected type of calculation) (e.g., a mouse click or finger tap gesturein the chart-calculations-options area 420 on an icon for another optionfor a type of data partitioning, such as “Table,” which corresponds tothe entire chart).

Because a different option for a type of data partitioning has beenselected, the chart is recalculated and visual marks 412 (FIG. 5C) arereplaced by visual marks 440. The percentages of visual marks 440 sum to100% because the “percent of total” calculation is for the entire chart.

FIG. 4G shows a UI 442 that is displayed in response to detecting aninput that selects another option for a type of data partitioning (for aselected type of calculation) (e.g., a mouse click or finger tap gesturein the chart-calculations-options area 420 on an icon for another optionfor a type of data partitioning, such as “Pane,” which corresponds toone pane 418-1 in the chart).

Because a different option for a type of data partitioning has beenselected, the chart is recalculated and visual marks 412 (FIG. 5C) arereplaced by visual marks 444. Visual marks in a set of visual marks(namely 444-1, 444-2, and 444-3) are visually distinguished from othervisual marks in the chart (namely 444-4 to 444-36), by highlighting orotherwise visually emphasizing visual marks in the set of marks and/orby dimming or otherwise visually deemphasizing the remaining visualmarks in the chart that are not part of the set of visual marks. Forexample, in FIG. 4G, visual marks 444-4 to 444-36 are dimmed, whilevisual marks 444-1 to 444-3 are not dimmed.

The set of visual marks (444-1 to 444-3) is distinct from the first setof visual marks (412-1 to 412-12).

The set of visual marks includes a visual mark (444-1) at the firstposition in the first pane 418-1, which was previously the location ofvisual mark 412-1 in the first set of visual marks. Visual mark 444-1has a current focus 416-4 (shown by the bold black border around mark444-1). In some embodiments, when the chart calculation options change,the set of visual marks that are visually distinguished from the othervisual marks in the chart includes a visual mark at the position in thechart that had current focus 416 immediately prior to changing the chartcalculation options. In some embodiments, when the chart calculationoptions change, the current focus 416 is put on a visual mark at adefault position in the chart, such as the top, leftmost position in thechart.

The set of visual marks (444-1 to 444-3) corresponds to the firstselected option for a type of calculation and a second selected optionfor a type of data partitioning (for a selected type of calculation). InFIG. 4G, the first selected option for a type of calculation is option422-1, a “percent of total” calculation. In FIG. 4G, the second selectedoption 424 for a type of data partitioning (for a selected type ofcalculation) is “Pane,” which corresponds to one pane 418 in the chart.By visually distinguishing the set of visual marks (444-1 to 444-3) fromother visual marks in the chart (444-4 to 444-36), the user is given avisual indication of what data is being used to calculate the valuesthat correspond to visual marks 444. For example, visuallydistinguishing a single pane of visual marks (444-1 to 444-3) informs auser that the “percent of total” calculation is for a total of 1 quarteracross 1 region. The percentages of the set of visual marks (444-1 to444-3) sum to 100%.

FIG. 4H shows a UI 448 that is the same as UI 442 (FIG. 4G), except thecursor/pointer 450-1 has been moved to visual mark 444-10.

FIG. 4I shows a UI 452 that is displayed in response to detecting aninput (e.g., a click on visual mark 444-10) that changes the currentfocus 416-5 to a visual mark (e.g., visual mark 444-10) in a second pane(e.g., 418-4) in the chart. Visual marks in a set of visual marks(namely 444-10 to 444-12) are visually distinguished from other visualmarks in the chart (namely 444-1 to 444-9 and 444-13 to 444-36), byhighlighting or otherwise visually emphasizing visual marks in the setof marks and/or by dimming or otherwise visually deemphasizing theremaining visual marks in the chart that are not part of the set ofvisual marks. For example, in FIG. 4I, visual marks 444-1 to 444-9 and444-13 to 444-36 are dimmed, while visual marks 444-10 to 444-12 are notdimmed.

The set of visual marks (444-10 to 444-12) is distinct from the firstset of visual marks (412-1 to 412-12). The set of visual marks includesthe visual mark (444-10) that has the current focus 416-5.

The set of visual marks corresponds to the first selected option for atype of calculation (e.g., option 422-1, a “percent of total”calculation) and a second selected option for a type of datapartitioning (for a selected type of calculation) (e.g., “Pane,” whichcorresponds to one pane in the chart). These options are the same as forvisual marks in FIG. 4G because the chart calculation options are thesame. As for the set of visual marks (444-1 to 444-3), by visuallydistinguishing the set of visual marks (444-10 to 444-12) from othervisual marks in the chart (444-1 to 444-9 and 444-13 to 444-36), theuser is given a visual indication of what data is being used tocalculate the values that correspond to visual marks 444. For example,visually distinguishing a single pane of visual marks (444-10 to 444-12)informs a user that the “percent of total” calculation is for a total of1 quarter across 1 region. The percentages of the set of visual marks(444-10 to 444-12) sum to 100%.

FIGS. 4J (with UI 454) and 4K (with UI 458) show an exemplary way tochange an option for a type of calculation 422 from a first option(e.g., a “Percent of Total” calculation) to a second option (e.g., a“Running Total” calculation) by clicking on option 422-1, displaying amenu with multiple options 422, and selecting “Running Total” option442-2.

FIG. 4L shows a UI 460 that is displayed detecting an input that selectsa second option for a type of calculation (e.g., a mouse click or fingertap gesture in the chart-calculations-options area on an icon for thesecond option for a type of calculation, such as “Running Total”)

Because a different option for a type of calculation has been selected,the chart is recalculated and visual marks 462 are displayed in place ofthe previously displayed visual marks (e.g., in place of marks 456 inFIG. 4K or, similarly, in place marks 412 in FIG. 4C). Visual marks in afourth set of visual marks (namely, 462-1 to 462-12) are visuallydistinguished from other visual marks in the chart (namely 462-13 to462-36), by highlighting or otherwise visually emphasizing visual marksin the fourth set of marks and/or by dimming or otherwise visuallydeemphasizing the remaining visual marks in the chart that are not partof the fourth set of visual marks. For example, in FIG. 4L, visual marks462-13 to 462-36 are dimmed, while visual marks 462-1 to 462-12 are notdimmed.

The fourth set of visual marks (462-1 to 462-12) is distinct from thefirst set of visual marks (412-1 to 412-12).

The fourth set of visual marks includes a visual mark (462-1) at thefirst position in the first pane 418-1, which was previously thelocation of visual mark 412-1 in the first set of visual marks. Visualmark 462-1 has a current focus 416-7 (shown by the bold black borderaround mark 462-1). In some embodiments, when the chart calculationoptions change, the set of visual marks that are visually distinguishedfrom the other visual marks in the chart includes a visual mark at theposition in the chart that had current focus 416 immediately prior tochanging the chart calculation options. In some embodiments, when thechart calculation options change, the current focus 416 is put on avisual mark at a default position in the chart, such as the top,leftmost position in the chart.

The fourth set of visual marks (462-1 to 462-12) corresponds to thesecond selected option for a type of calculation and a selected optionfor a type of data partitioning (for a selected type of calculation,such as the first selected option for a type of data partitioning). InFIG. 4L, the second selected option for a type of calculation is option422-2, a “running total” calculation. In FIG. 4L, a selected option 424for a type of data partitioning (for a “running total” calculation) is“Table (Across),” which corresponds to one row 414 in the chart. Byvisually distinguishing the fourth set of visual marks (462-1 to 462-12)from other visual marks in the chart (462-13 to 462-36), the user isgiven a visual indication of what data is being used to calculate thevalues that correspond to visual marks 462. For example, visuallydistinguishing a single row of visual marks (462-1 to 462-12) informs auser that the “running total” calculation is for a total of 12 monthsacross 1 region. In some embodiments, when a selected type ofcalculation is a running total, a respective numerical value for arespective visual mark in the running total is displayed with therespective visual mark (e.g., adjacent to the respective visual mark orwithin the respective visual mark). For example, visual marks 462-1 to462-12 have numerical values 1 to 12 in parentheses just above therunning total.

FIG. 4M shows a UI 464 for when the running total is over all the visualmarks 466 and the running total calculation corresponds to calculatedvalues progressing left-to-right, then top-to-bottom in the chart.

FIG. 4N shows a UI 468 for when the running total is over all the visualmarks 470 and the running total calculation corresponds to calculatedvalues progressing top-to-bottom, then left-to-right in the chart.

FIG. 4O shows a UI 472 with a set of visual marks visually distinguishedfrom other visual marks in the chart (e.g., visual marks 462-1 to 462-12are visually distinguished from visual marks 462-13 to 462-13).Pointer/cursor is placed over an icon to close thechart-calculations-options area 420.

FIG. 4P shows a UI 474 that is displayed in response to detecting aninput (e.g., a mouse click or finger tap gesture on the icon to closethe chart-calculations-options area 420). Display of thechart-calculations-options area 420 ceases and visual marks in the setof visual marks (462-1 to 462-12) are no longer visually distinguishedfrom other visual marks in the chart. Similarly, for any other set ofvisually distinguished marks described above, such as visual marks 412-1to 412-12 in FIG. 5C, visual marks in the set of visual marks are nolonger visually distinguished from other visual marks in the chart whenthe chart-calculations-options area 420 ceases to be displayed.

Attention is now directed towards methods that are, optionally,implemented on portable electronic device 100 or electronic device 200.

FIGS. 5A-5C are flow diagrams illustrating a method 500 of selecting anddisplaying chart calculation options in accordance with someembodiments. As indicated in the flow diagrams with dotted outlines,some of the features are optional. Implementations include variouscombinations of these optional features.

Method 500 is performed at an electronic device (e.g., portableelectronic device 100, FIG. 1, or electronic device 200, FIG. 2) with adisplay. In some embodiments, method 500 is governed by instructionsthat are stored in a non-transitory computer readable storage medium andthat are executed by one or more processors of a device, such as the oneor more processors 302 of portable electronic device 100 and/or the oneor more processors 352 of electronic device 200, as shown in FIGS.3A-3B. Some operations in method 500 are, optionally, combined and/orthe order of some operations is, optionally, changed.

The device displays (502) a chart on the display (e.g., chart 401). Thechart includes visual marks (e.g., bars in a bar chart, or othergraphics) that represent calculated values derived from a set of data(e.g., visual marks 412, FIG. 4C). The chart includes a plurality ofrows (e.g., rows 414) and a plurality of columns (e.g., columns 446and/or 434). The chart includes a plurality of panes formed byintersection of the plurality of rows and the plurality of columns(e.g., panes 418). A current focus is on a first visual mark at a firstposition in a first pane in the plurality of panes. For example, in FIG.5C, current focus 416-1 is on a first visual mark 412-1 at a firstposition in a first pane 418-1.

In some embodiments, a respective pane in the plurality of panesincludes (504) a plurality of visual marks. For example, panes 418include three visual marks per pane.

In some embodiments, a respective pane in the plurality of panesincludes (506) a plurality of visual marks, with each visual mark in theplurality of visual marks corresponding to a sub-column within therespective pane. For example, in FIG. 4A, visual mark 404-1 correspondsto sub-column 434-1, visual mark 404-2 corresponds to sub-column 434-2,and visual mark 404-3 corresponds to sub-column 434-3.

In some embodiments, a respective pane in the plurality of panesincludes (508) a plurality of visual marks, with each visual mark in theplurality of visual marks corresponding to a sub-row within therespective pane (not shown).

The device concurrently displays (510) a chart-calculations-options areawith the chart on the display (e.g., area 420, FIG. 4C). Thechart-calculations-options area includes display of one or more options(e.g., options 422, FIGS. 4C and 4J) for a type of calculation (e.g.,percent of total, percent from, difference from, percent differencefrom, rank, percentile, running total, and/or moving calculation) andone or more options (e.g., options 424, FIG. 5C) for a type of datapartitioning (for a selected type of calculation).

Exemplary options for the type of data partitioning include: perform theselected type of calculation on data that corresponds to each row in thechart (the “Table(Across)” option 424 in FIG. 4C); perform the selectedtype of calculation on data that corresponds to each column in the chart(the “Table(Down)” option 424 in FIG. 4E); perform the selected type ofcalculation on data that corresponds to the entire chart (the “Table”option 424 in FIG. 4F); perform the selected type of calculation on datathat corresponds to each pane in the chart (the “Pane” option 424 inFIG. 4G); perform the selected type of calculation on data thatcorresponds to calculated values progressing left-to-right, thentop-to-bottom in the chart (the “Table(Across then Down” option 424 inFIG. 4M); and perform the selected type of calculation on data thatcorresponds to calculated values progressing top-to-bottom, thenleft-to-right in the chart (the “Table(Down then Across” option 424 inFIG. 4N).

In some embodiments, the options for a type of data partitioning include(512) performing a selected type of calculation on data that correspondsto each row in the chart, performing a selected type of calculation ondata that corresponds to each column in the chart, performing a selectedtype of calculation on data that corresponds to the entire chart,performing a selected type of calculation on data that corresponds toeach pane in the chart, performing a selected type of calculation ondata that corresponds to calculated values progressing left-to-right,then top-to-bottom in the chart, and/or performing a selected type ofcalculation on data that corresponds to calculated values progressingtop-to-bottom, then left-to-right in the chart.

Visual marks in a first set of visual marks (e.g., visual marks 412-1 to412-12, FIG. 5C) are (514) visually distinguished from other visualmarks in the chart (e.g., by highlighting or otherwise visuallyemphasizing visual marks in the first set of marks and/or by dimming orotherwise visually deemphasizing the remaining visual marks in the chartthat are not part of the first set of visual marks). The first set ofvisual marks includes the first visual mark (e.g., visual mark 412-1,FIG. 5C). The first set of visual marks corresponds to a first selectedoption (e.g., option 422-1) for a type of calculation and a firstselected option (e.g., option 424, such as “Table(Across)” in FIG. 4C)for a type of data partitioning (for a selected type of calculation).

In some embodiments, when a selected type of calculation is a runningtotal, a respective numerical value for a respective visual mark in therunning total is (516) displayed with the respective visual mark (e.g.,adjacent to the respective visual mark or within the respective visualmark), as shown for the running totals in FIGS. 4L-4N.

In some embodiments, the device detects (518) an input that selects asecond option for a type of data partitioning (for a selected type ofcalculation) (e.g., a mouse click or finger tap gesture in thechart-calculations-options area on an icon 424 for the second option fora type of data partitioning, such as a click on “Table(Down),” whichcorresponds to one column 434-1 in the chart), distinct from the firstoption for a type of data partitioning (for a selected type ofcalculation).

In some embodiments, in response to detecting the input that selects thesecond option for a type of data partitioning (for a selected type ofcalculation), the device visually distinguishes (520) visual marks in asecond set of visual marks (e.g., visual marks 436-1, 436-13, and436-25, FIG. 4E) from other visual marks in the chart (e.g., byhighlighting or otherwise visually emphasizing visual marks in thesecond set of marks and/or by dimming or otherwise visuallydeemphasizing the remaining visual marks in the chart that are not partof the second set of visual marks). The second set of visual marks isdistinct from the first set of visual marks. The second set of visualmarks includes a visual mark at the first position in the first pane(e.g., visual mark 436-1, FIG. 4E). The second set of visual markscorresponds to the first selected option for a type of calculation andthe second selected option for a type of data partitioning (for aselected type of calculation). In FIG. 4E, the first selected option fora type of calculation is option 422-1, a “percent of total” calculation.In FIG. 4E, the second selected option 424 for a type of datapartitioning (for a selected type of calculation) is “Table (Down),”which corresponds to one column 434 in the chart.

In some embodiments, while displaying visual marks in the first set ofvisual marks visually distinguished from other visual marks in thechart, the device detects (522) an input that changes the current focusto a second visual mark in a second pane in the plurality of panes(e.g., a mouse click or finger tap gesture on the second visual mark,such as a click on visual mark 412-13 in FIG. 4D), distinct from thefirst visual mark. In response to detecting the input that changes thecurrent focus to a second visual mark in a second pane in the pluralityof panes, the device visually distinguishes visual marks in a third setof visual marks (visual marks 412-13 to 412-24, FIG. 4D) from othervisual marks in the chart (e.g., by highlighting or otherwise visuallyemphasizing visual marks in the third set of marks and/or by dimming orotherwise visually deemphasizing the remaining visual marks in the chartthat are not part of the third set of visual marks). The third set ofvisual marks is distinct from the first set of visual marks. The thirdset of visual marks includes the second visual mark. The third set ofvisual marks corresponds to the first selected option for a type ofcalculation and the first selected option for a type of datapartitioning (for a selected type of calculation).

In some embodiments, while displaying visual marks in the first set ofvisual marks visually distinguished from other visual marks in the chartwith the current focus on the first visual mark, the device detects(524) an input that selects a second option for a type of calculation(e.g., a mouse click or finger tap gesture in thechart-calculations-options area on an icon for the second option for atype of calculation, like that discussed above with respect to FIGS.4J-4K), distinct from the first option for a type of calculation. Inresponse to detecting the input that selects the second option for atype of calculation, the device visually distinguishes visual marks in afourth set of visual marks (e.g., visual marks 462-1 to 462-12, FIG. 4L)from other visual marks in the chart (e.g., by highlighting or otherwisevisually emphasizing visual marks in the fourth set of marks and/or bydimming or otherwise visually deemphasizing the remaining visual marksin the chart that are not part of the fourth set of visual marks). Thefourth set of visual marks is distinct from the first set of visualmarks. The fourth set of visual marks includes a visual mark at thefirst position in the first pane. The fourth set of visual markscorresponds to the second selected option for a type of calculation anda selected option for a type of data partitioning (for a selected typeof calculation, such as the first selected option for a type of datapartitioning). For example, in FIG. 4L, the second selected option for atype of calculation is option 422-2, a “running total” calculation. InFIG. 4L, a selected option 424 for a type of data partitioning (for a“running total” calculation) is “Table (Across),” which corresponds toone row 414 in the chart.

In some embodiments, while displaying visual marks in the first set ofvisual marks visually distinguished from other visual marks in thechart, the device detects (526) a first input (e.g., a mouse click orfinger tap gesture on an icon to close the chart-calculations-optionsarea 420). In response to detecting the first input, the device ceasesto display the chart-calculations-options area and ceases to visuallydistinguish visual marks in the first set of visual marks from othervisual marks in the chart, as illustrated in FIGS. 4O-4P.

Although some of various drawings illustrate a number of logical stagesin a particular order, stages that are not order dependent may bereordered and other stages may be combined or broken out. While somereordering or other groupings are specifically mentioned, others will beobvious to those of ordinary skill in the art, so the ordering andgroupings presented herein are not an exhaustive list of alternatives.Moreover, it should be recognized that the stages could be implementedin hardware, firmware, software or any combination thereof.

The foregoing description, for purpose of explanation, has beendescribed with reference to specific embodiments. However, theillustrative discussions above are not intended to be exhaustive or tolimit the scope of the claims to the precise forms disclosed. Manymodifications and variations are possible in view of the aboveteachings. The embodiments were chosen in order to best explain theprinciples underlying the claims and their practical applications, tothereby enable others skilled in the art to best use the embodimentswith various modifications as are suited to the particular usescontemplated.

What is claimed is:
 1. A method, comprising: at an electronic devicewith a display: displaying a chart on the display, wherein: the chartincludes visual marks that represent calculated values derived from aset of data; the chart includes a plurality of rows and a plurality ofcolumns; the chart includes a plurality of panes formed by intersectionof the plurality of rows and the plurality of columns; and a currentfocus is on a first visual mark at a first position in a first pane inthe plurality of panes; concurrently displaying achart-calculations-options area with the chart on the display, wherein:the chart-calculations-options area includes display of one or moreoptions for a type of calculation, and one or more options for a type ofdata partitioning; and visual marks in a first set of visual marks arevisually distinguished from other visual marks in the chart, wherein:the first set of visual marks includes the first visual mark, and thefirst set of visual marks corresponds to a first selected option for atype of calculation and a first selected option for a type of datapartitioning; detecting an input that selects a second option for a typeof data partitioning, distinct from the first option for a type of datapartitioning; and, in response to detecting the input that selects thesecond option for a type of data partitioning, visually distinguishingvisual marks in a second set of visual marks from other visual marks inthe chart, wherein: the second set of visual marks is distinct from thefirst set of visual marks, the second set of visual marks includes avisual mark at the first position in the first pane, and the second setof visual marks corresponds to the first selected option for a type ofcalculation and the second selected option for a type of datapartitioning.
 2. The method of claim 1, wherein a respective pane in theplurality of panes includes a plurality of visual marks.
 3. The methodof claim 2, wherein each visual mark in the plurality of visual markscorresponds to a sub-column within the respective pane.
 4. The method ofclaim 2, wherein each visual mark in the plurality of visual markscorresponds to a sub-row within the respective pane.
 5. The method ofclaim 1, including: while displaying visual marks in the first set ofvisual marks visually distinguished from other visual marks in thechart, detecting an input that changes the current focus to a secondvisual mark in a second pane in the plurality of panes, distinct fromthe first visual mark; and, in response to detecting the input thatchanges the current focus to a second visual mark in a second pane inthe plurality of panes, visually distinguishing visual marks in a thirdset of visual marks from other visual marks in the chart, wherein: thethird set of visual marks is distinct from the first set of visualmarks, the third set of visual marks includes the second visual mark,and the third set of visual marks corresponds to the first selectedoption for a type of calculation and the first selected option for atype of data partitioning.
 6. The method of claim 1, including: whiledisplaying visual marks in the first set of visual marks visuallydistinguished from other visual marks in the chart with the currentfocus on the first visual mark, detecting an input that selects a secondoption for a type of calculation, distinct from the first option for atype of calculation; and, in response to detecting the input thatselects the second option for a type of calculation, visuallydistinguishing visual marks in a fourth set of visual marks from othervisual marks in the chart, wherein: the fourth set of visual marks isdistinct from the first set of visual marks, the fourth set of visualmarks includes a visual mark at the first position in the first pane,and the fourth set of visual marks corresponds to the second selectedoption for a type of calculation and a selected option for a type ofdata partitioning.
 7. The method of claim 1, wherein the options for atype of data partitioning include performing a selected type ofcalculation on data that corresponds to each row in the chart,performing a selected type of calculation on data that corresponds toeach column in the chart, performing a selected type of calculation ondata that corresponds to the entire chart, performing a selected type ofcalculation on data that corresponds to each pane in the chart,performing a selected type of calculation on data that corresponds tocalculated values progressing left-to-right, then top-to-bottom in thechart, and/or performing a selected type of calculation on data thatcorresponds to calculated values progressing top-to-bottom, thenleft-to-right in the chart.
 8. The method of claim 1, wherein, when aselected type of calculation is a running total, a respective numericalvalue for a respective visual mark in the running total is displayedwith the respective visual mark.
 9. The method of claim 1, including:while displaying visual marks in the first set of visual marks visuallydistinguished from other visual marks in the chart, detecting a firstinput; and, in response to detecting the first input: ceasing to displaythe chart-calculations-options area and ceasing to visually distinguishvisual marks in the first set of visual marks from other visual marks inthe chart.
 10. An electronic device, comprising: a display; one or moreprocessors; memory; and one or more programs, wherein the one or moreprograms are stored in the memory and configured to be executed by theone or more processors, the one or more programs including instructionsfor: displaying a chart on the display, wherein: the chart includesvisual marks that represent calculated values derived from a set ofdata; the chart includes a plurality of rows and a plurality of columns;the chart includes a plurality of panes formed by intersection of theplurality of rows and the plurality of columns; and a current focus ison a first visual mark at a first position in a first pane in theplurality of panes; concurrently displaying a chart-calculations-optionsarea with the chart on the display, wherein: thechart-calculations-options area includes display of one or more optionsfor a type of calculation, and one or more options for a type of datapartitioning; and visual marks in a first set of visual marks arevisually distinguished from other visual marks in the chart, wherein:the first set of visual marks includes the first visual mark, and thefirst set of visual marks corresponds to a first selected option for atype of calculation and a first selected option for a type of datapartitioning; detecting an input that selects a second option for a typeof data partitioning, distinct from the first option for a type of datapartitioning; and, in response to detecting the input that selects thesecond option for a type of data partitioning, visually distinguishingvisual marks in a second set of visual marks from other visual marks inthe chart, wherein: the second set of visual marks is distinct from thefirst set of visual marks, the second set of visual marks includes avisual mark at the first position in the first pane, and the second setof visual marks corresponds to the first selected option for a type ofcalculation and the second selected option for a type of datapartitioning.
 11. The electronic device of claim 10, wherein arespective pane in the plurality of panes includes a plurality of visualmarks, with each visual mark in the plurality of visual markscorresponding to a sub-column within the respective pane.
 12. Theelectronic device of claim 10, wherein a respective pane in theplurality of panes includes a plurality of visual marks, with eachvisual mark in the plurality of visual marks corresponding to a sub-rowwithin the respective pane.
 13. The electronic device of claim 10,wherein the one or more programs further include instructions for: whiledisplaying visual marks in the first set of visual marks visuallydistinguished from other visual marks in the chart, detecting an inputthat changes the current focus to a second visual mark in a second panein the plurality of panes, distinct from the first visual mark; and, inresponse to detecting the input that changes the current focus to asecond visual mark in a second pane in the plurality of panes, visuallydistinguishing visual marks in a third set of visual marks from othervisual marks in the chart, wherein: the third set of visual marks isdistinct from the first set of visual marks, the third set of visualmarks includes the second visual mark, and the third set of visual markscorresponds to the first selected option for a type of calculation andthe first selected option for a type of data partitioning.
 14. Theelectronic device of claim 10, wherein the one or more programs furtherinclude instructions for: while displaying visual marks in the first setof visual marks visually distinguished from other visual marks in thechart with the current focus on the first visual mark, detecting aninput that selects a second option for a type of calculation, distinctfrom the first option for a type of calculation; and, in response todetecting the input that selects the second option for a type ofcalculation, visually distinguishing visual marks in a fourth set ofvisual marks from other visual marks in the chart, wherein: the fourthset of visual marks is distinct from the first set of visual marks, thefourth set of visual marks includes a visual mark at the first positionin the first pane, and the fourth set of visual marks corresponds to thesecond selected option for a type of calculation and a selected optionfor a type of data partitioning.
 15. The electronic device of claim 10,wherein the options for a type of data partitioning include performing aselected type of calculation on data that corresponds to each row in thechart, performing a selected type of calculation on data thatcorresponds to each column in the chart, performing a selected type ofcalculation on data that corresponds to the entire chart, performing aselected type of calculation on data that corresponds to each pane inthe chart, performing a selected type of calculation on data thatcorresponds to calculated values progressing left-to-right, thentop-to-bottom in the chart, and/or performing a selected type ofcalculation on data that corresponds to calculated values progressingtop-to-bottom, then left-to-right in the chart.
 16. A non-transitorycomputer readable storage medium storing one or more programs comprisinginstructions configured for execution by an electronic device with adisplay, the one or more programs including instructions for: displayinga chart on the display, wherein: the chart includes visual marks thatrepresent calculated values derived from a set of data; the chartincludes a plurality of rows and a plurality of columns; the chartincludes a plurality of panes formed by intersection of the plurality ofrows and the plurality of columns; and a current focus is on a firstvisual mark at a first position in a first pane in the plurality ofpanes; concurrently displaying a chart-calculations-options area withthe chart on the display, wherein: the chart-calculations-options areaincludes display of one or more options for a type of calculation, andone or more options for a type of data partitioning; and visual marks ina first set of visual marks are visually distinguished from other visualmarks in the chart, wherein: the first set of visual marks includes thefirst visual mark, and the first set of visual marks corresponds to afirst selected option for a type of calculation and a first selectedoption for a type of data partitioning; detecting an input that selectsa second option for a type of data partitioning, distinct from the firstoption for a type of data partitioning; and, in response to detectingthe input that selects the second option for a type of datapartitioning, visually distinguishing visual marks in a second set ofvisual marks from other visual marks in the chart, wherein: the secondset of visual marks is distinct from the first set of visual marks, thesecond set of visual marks includes a visual mark at the first positionin the first pane, and the second set of visual marks corresponds to thefirst selected option for a type of calculation and the second selectedoption for a type of data partitioning.
 17. The computer readablestorage medium of claim 16, wherein a respective pane in the pluralityof panes includes a plurality of visual marks, with each visual mark inthe plurality of visual marks corresponding to a sub-column within therespective pane.
 18. The computer readable storage medium of claim 16,wherein a respective pane in the plurality of panes includes a pluralityof visual marks, with each visual mark in the plurality of visual markscorresponding to a sub-row within the respective pane.
 19. The computerreadable storage medium of claim 16, wherein the one or more programsfurther include instructions for: while displaying visual marks in thefirst set of visual marks visually distinguished from other visual marksin the chart, detecting an input that changes the current focus to asecond visual mark in a second pane in the plurality of panes, distinctfrom the first visual mark; and, in response to detecting the input thatchanges the current focus to a second visual mark in a second pane inthe plurality of panes, visually distinguishing visual marks in a thirdset of visual marks from other visual marks in the chart, wherein: thethird set of visual marks is distinct from the first set of visualmarks, the third set of visual marks includes the second visual mark,and the third set of visual marks corresponds to the first selectedoption for a type of calculation and the first selected option for atype of data partitioning.
 20. The computer readable storage medium ofclaim 16, wherein the one or more programs further include instructionsfor: while displaying visual marks in the first set of visual marksvisually distinguished from other visual marks in the chart with thecurrent focus on the first visual mark, detecting an input that selectsa second option for a type of calculation, distinct from the firstoption for a type of calculation; and, in response to detecting theinput that selects the second option for a type of calculation, visuallydistinguishing visual marks in a fourth set of visual marks from othervisual marks in the chart, wherein: the fourth set of visual marks isdistinct from the first set of visual marks, the fourth set of visualmarks includes a visual mark at the first position in the first pane,and the fourth set of visual marks corresponds to the second selectedoption for a type of calculation and a selected option for a type ofdata partitioning.